Table Object Functions and Methods
Description
Available functions and methods for the Table objects.
- Name
- Description
- Contrasting TABLE.OPEN with TABLE.CURRENT and TABLE.GET
TABLE.OPEN() opens a new instance of a table. This new instance has its own record pointer, queries, etc. TABLE.CURRENT() and TABLE.GET(), on the other hand, get a pointer to an already open table. These methods do not open a new instance of that table.
- -> (Parent Child Relationship)
When you need to provide a fully qualified field name in an expression, you place -> between the Table_Name and Field_Name. This is necessary when an expression contains references to fields in multiple tables or when an expression does not have a table context that supplies a default value for Table_Name.
- TABLE.CREATE_END Function
The TABLE.CREATE_END() method completes the definition of a table structure that was initiated by the TABLE.CREATE_BEGIN() method, creates the table file, and returns a pointer. After the table file is created, it is opened and ready for use.
Related Functions and Methods
- RECORD_DELETE Function
Deletes one or more record(s) in a table that match the filter condition
- ENTER_RECORD Method
Allows for data to be entered when using Xbasic with a Form or Browse. Returns a dot variable that is the validation object.
- CHANGE_RECORD Method
Allows for data to be changed via Xbasic, when using a Form or Browse. Returns a dot variable that is the validation object.
- DELETE_RECORD Method
Allows for data to be deleted via Xbasic, when using a Form or Browse. Returns a dot variable that is the validation object.
Methods
- TABLE.ACTUAL_FILENAME_GET Method
Get the physical (master) filename of the table, if name specified, returns full path to provided database name.
- TABLE.ADD_BLANK_RECORDS Method
Adds blank records to a DBF table.
- TABLE.ADD_FIELDS Method
Adds fields to a table. New_fields is a crlf list of fields to be added in format: fieldname,type,size,decimals
- TABLE.APPEND Method
Append the records of one table to another, optional argument provides a quick way to append records of exact same table structure. Specify the required values in the Append dot variable, then use the following command: <TBL>.APPEND()
- TABLE.BATCH_BEGIN Method
Lock database file for batched changes.
- TABLE.BATCH_END Method
Unlocks database file after batched changes.
- TABLE.BOF Method
Returns TRUE if we are on the first record of the specified (or current) search order.
- TABLE.CHANGE_BEGIN Method
Begin changes to tables current record.
- TABLE.CHANGE_END Method
End changes to tables current record.
- TABLE.CHILD_GET Method
Returns names of children of table [or a single child if number is provided].
- TABLE.CLOSE Method
Close an open table.
- TABLE.COMPACT Method
Compact DBF,SET,DDD,ALB files.
- TABLE.COPY Method
Copy all or some of the fields from the table to another table or set.
- TABLE.COPY_RECORD_TO Method
Copies current record to another table with similar structure as current table.
- TABLE.COPY_RECORDS_TO Method
Copies records to another table with similar structure
- TABLE.CREATE_BEGIN Method
Start defining a new Table, defines the first field.
- TABLE.CREATE_CLONE Method
Create an empty copy of the table.
- TABLE.CREATE_SHADOW Method
Create a shadow table - the shadowfilename is the table created, it points to the actualfilename.
- TABLE.CROSSTAB Method
Cross tabulate records of database into result database.
- TABLE.CURRENT Method
The TABLE.CURRENT() method returns an object pointer to an open table in the current session. Use TABLE.CURRENT()without a parameter to return a pointer to the session's primary table. If no table is found in a particular slot, TABLE.CURRENT()creates an invalid object pointer. You can test the validity of an object pointer using the IS_OBJECT() function. You can also get a pointer to an open table using the TABLE.GET() method. For example, if you have opened a set and you want to get a pointer to one of the child tables in the set, (say "Invoice_Items"), you could use this command:
- TABLE.DECRYPT Method
Decrypt a database file.
- TABLE.DELETE Method
Mark the current record for deletion.
- TABLE.DELETE_DUPS Method
Deletes the duplicate records in the table.
- TABLE.DELETE_FIELDS Method
Removes fields from a table. Field_list is a crlf list of fields to be removed.
- TABLE.DELETE_RANGE Method
Delete a range of records in the table.
- TABLE.DUPLICATE Method
Create a copy of the table, with all records and layouts.
- TABLE.ENCRYPT Method
Encrypt a database file.
- TABLE.ENCRYPTED Method
Returns TRUE if table is encrypted.
- TABLE.ENUM_OPEN Method
Enumerate all open tables.
- TABLE.ENUM_SESSION_OPEN Method
Enumerate all open tables in the current session.
- TABLE.ENUM_SYNTAX Method
Enumerate ODBC driver syntax elements.
- TABLE.EOF Method
Returns TRUE if we are on the last record of the specified (or current) search order.
- TABLE.ERASE Method
Delete the table if safety is TRUE.
- TABLE.EVAL Method
Evaluate an expression in the context of the table.
- TABLE.EVAL_VALID Method
Returns TRUE if expression is valid in the context of the table.
- TABLE.EXPORT Method
Export records in table to specified output file.
- TABLE.EXTERNAL_CALCS_GET Method
The TABLE.EXTERNAL_CALCS_GET() method returns a list of externally defined calculated fields for a table.
- TABLE.EXTERNAL_FIELD_INFO_GET Method
Retrieve external tables field names (and other optional info) in a cr-lf separated list. format same as External_Field_Name_Get().
- TABLE.EXTERNAL_FIELD_NAME_GET Method
Retrieve external tables field names (and other optional info) in a cr-lf separated list.
- TABLE.EXTERNAL_INDEX_DEF_ENUM Method
Retrieve all tags a table or setname and description - format A=Active E=Error N=Name P=Filename O=order,F=filter,X=all flags, U=nique, D=escending, I=Insensitive T=Type.
- TABLE.EXTERNAL_INDEX_DEF_FROM_NAME_GET Method
Retrieve a external tag information given a table or setname and description - format E=Error P=Filename O=order,F=filter,X=all flags, U=Unique, D=escending, I=Insensitive T=Type.
- TABLE.EXTERNAL_INDEX_NAME_GET Method
Retrieve external tables index tag names in a cr-lf separated list.
- TABLE.EXTERNAL_RECORD_CONTENT_FROM_KEY_GET Method
Retrieve external tables records in a cr-lf separated list given a list of records or keys.
- TABLE.EXTERNAL_RECORD_CONTENT_GET Method
Retrieve external tables records in a cr-lf separated list.
- TABLE.External_Suggest Method
Returns a list of suggestions from a field or expression in a table.
- TABLE.EXTERNAL_VARIABLES_GET Method
The TABLE.EXTERNAL_VARIABLES_GET() method returns a list of externally defined variables.
- TABLE.FETCH_EOF Method
The <TBL>.FETCH_EOF() method returns TRUE (.T.) if the most recent fetch in the table or set referenced by the <TBL> object pointer has tried to read past the end of the file, creating an end of file condition. The meaning of end of file differs depending on how the records are currently arranged through the primary index, active range, or current query list. The end of file condition occurs when trying to read beyond the first or last physical record (in record number order), or beyond the first or last record in the current ordering and selection of records.
- TABLE.FETCH_FIND Method
Using the current index, find specified key value, return record number.
- TABLE.FETCH_FIRST Method
Fetch the first record in the table/set. returns TRUE if record found.
- TABLE.FETCH_GOTO Method
Goto a specific record number in the table, returns positive if record found, else negitive record number.
- TABLE.FETCH_LAST Method
Fetch the last record in the table/set. returns TRUE if record found.
- TABLE.FETCH_LOC_NEXT Method
Locate the next value/pattern if the field specified.
- TABLE.FETCH_LOC_PREV Method
Locate the previos value/pattern if the field specified.
- TABLE.FETCH_NEXT Method
Fetch the next record in the table/set. returns TRUE if record found.
- TABLE.FETCH_PREV Method
Fetch the previous record in the table/set. returns TRUE if record found.
- TABLE.FIELD_ADD Method
Define the next field in a table.
- TABLE.FIELD_BLANK Method
Places a blank value in the field specified.
- TABLE.FIELD_GET Method
Get a field given a name or index into current Table.
- TABLE.FIELD_INFO_DUMP Method
Displays a CRLF delimited list of info about fields in the table. Format is same format as 'table.external_field_name_get()'
- TABLE.FIELD_NAME_GET Method
Retrieve field names in a cr-lf separated list.
- TABLE.FIELD_SPACE_USAGE Method
Visits all records and dumps field name + space used.
- TABLE.FIELD_STATISTICS Method
Collects statistics for passed in expression/field.
- TABLE.FIELDNAME_CHANGE Method
Change the names of fields in a table without restructuring the table.
- TABLE.FIELDS_GET Method
Returns the number of fields in a record for the table referenced by <TBL>. The FIELDS_GET() method is most useful when you do not know much about the table you are using. After determining the Number_of_Fields available, you can then get an object pointer to each field in the table using the <TBL>.FIELD_GET() method.
- TABLE.FILE_MODE_GET Method
Get the sharing mode of the file the table.
- TABLE.FILENAME_GET Method
Get the filename of the table, if name specified, returns full path to provided database name.
- TABLE.GET Method
The TABLE.GET() method takes the Alias of an open table and returns an object pointer to this table. Use this method when you know the alias of a open table, but you do not have a pointer to it. You need a pointer to a table to use any of the methods to manipulate a table. To obtain a pointer to a table when you do not know the alias name, use the TABLE.CURRENT() method.
- TABLE.Get_Cursor Method
Returns 'cursor' for table (keeps own position).
- TABLE.GET_GROUP_NAME Method
Returns name of associated groups (table or report level if defined).
- TABLE.GET_INDEX_EXTENSION Method
Returns the Index file extension that would be associated with the passed in Table extension.
- TABLE.GET_MEMO_EXTENSION Method
Returns the Memo file extension that would be associated with the passed in Table extension.
- TABLE.GET_SOURCE_TYPE Method
Returns the type of source the table is - Native, ODBC , Native-Encrypted.
- TABLE.GET_SYNTAX Method
Get syntax for an ODBC setting.
- TABLE.HANDLE Method
Get the tables an old style 'handle'.
- TABLE.HANDLE_SET Method
Given an old style 'handle', set the table pointer.
- TABLE.HANDLES_IN_USE Method
Get a crlf-delimited string of table handles in use.
- TABLE.IMPORT Method
Import records from specified input file to the table.
- TABLE.IMPORT_ASCII_TABLE Method
Imports a fixed length ascii file into an existing table. Ascii file must match the structure of the table. If ascii file has fieldnames, set skip_lines to 1
- TABLE.IN_USE Method
Returns true if the named table/library is in use (does exclusive open test).
- TABLE.INDEX_ADD Method
The .INDEX_ADD() method adds another index tag to the index file created by TABLE.INDEX_CREATE_BEGIN() .
- TABLE.INDEX_CREATE_BEGIN Method
Begin creation of a new index, add the first tag.
- TABLE.INDEX_CREATE_END Method
Complete creation of an index.
- TABLE.INDEX_GET Method
Returns an index given a name.
- TABLE.INDEX_NAME_GET Method
Retrieve open index tag names (from 1 to n) - if parameter ommitted, report ALL names.
- TABLE.INDEX_OPEN Method
Open an index file for the database.
- TABLE.INDEX_PRIMARY_GET Method
Get the primary index for the table.
- TABLE.INDEX_PRIMARY_PUT Method
Set the primary index for the table, using either name or Index object.
- TABLE.INDEX_RECORD_GET Method
Get the record number order index object for a table.
- TABLE.INDEX_TAG_ADD Method
Add a tag to the production index for the database.
- TABLE.INTERSECT Method
Create a new table that is the intersection between the table and a secondary table.
- TABLE.IS_DELETED Method
Is the current record Deleted.
- TABLE.IS_MARKED Method
Is the current record Marked.
- TABLE.IS_RECORD_LOCKED Method
return TRUE if the record is locked.
- TABLE.IS_UNMARKED Method
Is the current record Unmarked.
- TABLE.IS_VALID Method
Is the current table valid.
- TABLE.ISOPEN Method
Test if a table is open - return .T. if table is currently open.
- TABLE.JOIN Method
Create a new table by merging the records from the table with a secondary table.
- TABLE.LINK_EXPR_GET Method
The .LINK_EXPR_GET() method returns the expression that links two tables in a set.
- TABLE.LINK_FILTER_EXPR_GET Method
The .LINK_FILTER_EXPR_GET() method returns the filter expression set when linking two tables in a set.
- TABLE.LINK_INDEX_FLAGS_GET Method
The .LINK_INDEX_FLAGS_GET() method returns the options set when linking two tables in a set.
- TABLE.LOGICALRECORD_GET Method
Gets the current record's logical position in the current sort order
- TABLE.LOGICALRECORD_SET Method
Sets the record pointer to a logical record number in the current sort order. Returns .t. if the requested logical record number exits, else .f.
- TABLE.MARK Method
Mark the current record.
- TABLE.MARK_DUPS Method
Marks the duplicate records in the table.
- TABLE.MARK_DUPS2 Method
Marks the duplicate records in the table, including the original record.
- TABLE.MARK_RANGE Method
Mark a range of records in the table.
- TABLE.MEMO_CHECK Method
Validate the structure of a memo file flags (v-alidate,f-ilemapping,fs-file mapping with sample,r=# - start at record).
- TABLE.MERGE_DATA Method
- TABLE.MODE_GET Method
Get the data entry mode for the table.
- TABLE.MOVE Method
Moves forward or backwards the specified NumberOfRecords in the current sort order. Returns the record number of the target record.
- TABLE.MOVE_RECORD_TO Method
Moves the current record to another table with the same structure.
- TABLE.MOVE_RECORDS_TO Method
Moves records to another table with similar structure
- TABLE.NAME_GET Method
Get the name or alias of the table.
- TABLE.NAME_NORMALIZE Method
Normalize a table name.
- TABLE.OPEN Method
Open an existing table.
- TABLE.OPEN_SESSION Method
Open an existing table in a new session.
- TABLE.OPENMAP Method
Creates a pointer to an open table and only contains the fields specified in the fieldList.
- TABLE.ORDER Method
Orders and (optionally) filters a DBF table.
- TABLE.PACK Method
Removes all the records that are marked for deletion.
- TABLE.PARENT_GET Method
Returns name of the parent table.
- TABLE.PARENT_LINK_EXPR_GET Method
Returns the parent linking expression.
- TABLE.PERSIST Method
Flags opened table to not be closed automatically on termination of script.
- TABLE.POPULATE_FROM_STRING Method
Populate a table from a string.
- TABLE.POPULATE_GRID Method
Populate via arrays a grid - use $row$ and $column$ as placeholders for the row/column index.
- TABLE.POST Method
Specify the required values in the Post dot variable, then use the following command:
- TABLE.PREVIOUS_RECORD Method
Returns the previous record data entry was performed on.
- TABLE.QUERIES_REOPEN Method
Reopen the queries in a session.
- TABLE.QUERY_CREATE Method
Creates a new query.
- TABLE.QUERY_DETACH Method
Detach current query (or named query if specified).
- TABLE.QUERY_DETACH_ALL Method
Detach all queries.
- TABLE.QUERY_FROM_RANGE Method
Create a query from the current range, if one is in effect - returns .T. if new query created.
- TABLE.QUERY_PRIMARY_PUT Method
Returns existing query if already run, else runs and returns saved query.
- TABLE.RANGE_ADD Method
Add a range filter to the table.
- TABLE.RANGE_DROP Method
Drop the current range from the table.
- TABLE.RECALC_CALCFIELDS Method
Recalculates all calc fields defined in Field Rules
- TABLE.RECNO Method
Return the current record for the table.
- TABLE.RECORD_CLONE Method
Create a new record using the fields from a similar table.
- TABLE.RECORD_CONTENT_GET Method
Retrieve record data in a cr-lf separated list.
- TABLE.RECORD_DATA_GET Method
Return the all the data from the current records field as a blob.
- TABLE.RECORD_DATA_SET Method
Set all the feilds int the current record using data from a blob.
- TABLE.RECORD_TO_VARS Method
convert a record to a set of variables in vars
- TABLE.RECORDS_DELETED Method
Returns a count of the records deleted.
- TABLE.RECORDS_GET Method
Returns the number of records in the table.
- TABLE.REFERENCE_EXPRESSION_GET Method
Get the expression needed to reconstruct a pointer.
- TABLE.REFRESH Method
Perform network refresh, return True if changed.
- TABLE.RELATED_TABLES_GET Method
Return the tables in a set that can be represented with a lookup expression to the table.
- TABLE.RELATION_ADD Method
Add a relation to a table.
- TABLE.RELATION_CHANGE Method
Change a relation's settings.
- TABLE.RELATION_DROP Method
Remove a relation from a table.
- TABLE.RELATION_GET Method
Returns the tables relation type (Single/Many).
- TABLE.RELATION_TAG Method
Builds and Returns an index handle for the relation_change and relation_add commands.
- TABLE.REMVE_RECS_IN_LIST Method
Removes the records Remove_List from the Primary_table. Records are matched on the Primary_table_key
- TABLE.RENAME Method
Renames the table.
- TABLE.RESET Method
Open the primary table for the session.
- TABLE.RULES_GET Method
Provides access to the tables field rules.
- TABLE.SEND Method
Zip and send a table. Options "d" - include Dictionary, "x" - include Indexes, "p" - display prompt dialog, "c" - compress before sending.
- TABLE.ServerSide_Records_Get Method
Returns the number of records in an active-link table. Faster than <tbl>.Records_Get() because it does not cause the local record cache to become fully populated.
- TABLE.SESSIONHANDLE Method
Return the session that the table is opened under.
- TABLE.SET_CREATE Method
Use the current table to define a new set of provided filename.
- Table.SQL_Open Method
Create a temporary table from a SQL statement.
- Table.SQL_Reset Method
Create a temporary table from a SQL statement and make it the primary table of the current session. Open a just-in-time SQL as the primary table.
- TABLE.SUBTRACT Method
Create a new table of records not common to table and secondary table.
- TABLE.Suggest Method
Suggest a list of possible values given a sample value (to drive auto-complete).
- TABLE.SUMMARIZE Method
Summarize the records of the table into a specified output table.
- TABLE.TEMPORARY_CLOSE Method
Close temporary tables (ignores non-cached tables).
- TABLE.TEMPORARY_OPEN Method
Opens temporary tables for caching.
- TABLE.to_sql_expression Method
If convertable to a SQL level expression, return than expression.
- TABLE.to_sql_filter Method
If expression can be converted in whole OR partically to a SQL order, return the SQL portion, or both portions if a separator is provided.
- TABLE.to_sql_order Method
If expression can be converted in whole OR partically to a SQL filter, return the SQL portion, or both portions if a separator is provided.
- TABLE.UNDELETE Method
Un-delete records in a table
- TABLE.UNMARK Method
Unmarks the current record.
- TABLE.UNMARK_DUPS Method
Unmarks the duplicate records in the table.
- TABLE.UNMARK_RANGE Method
Unmark a range of records in the table.
- TABLE.UPDATE Method
Update all records in table using expressions.
- TABLE.UPDATE_PRODUCTION_INDEX Method
Update the production index associated with the table.
- TABLE.XML_EXPORT Method
Exports data from a table to an XML file. Specify * to export all fields.
- TABLE.ZAP Method
Delete all the records in the table if safety is TRUE.
- TABLE.ZIP Method
Zip a table.
- TBL.ENTER_BEGIN Method
Initiates an Enter operation to add a new record.
- TBL.ENTER_END Method
Completes the creation of a new table record.
- TBL.NAME_REAL_GET Method
Returns the Table_Name of the table referenced by <TBL>.
- TBL.NEED_REFRESH Method
Returns true when a refresh is needed
See Also